.. _`Replace values in Tables`:

.. _`org.sysess.sympathy.data.table.tablevaluesearchreplacemultiple`:

Replace values in Tables
````````````````````````

.. image:: search_replace.svg
   :width: 48


Search and replace values in Table.




Documentation
:::::::::::::

Auto generated list version of :ref:`Replace values in Table`.

In this version, the following ports from the original nodes have been
changed to lists which the node loops over:

    :Looped Inputs: table.
    :Looped Outputs: table.

For details see the original node.


Definition
::::::::::


Input ports
...........

    **tables**  [table]
        Input Table


Output ports
............

    **tables**  [table]
        Table with replaced values




Configuration
.............

    **Select columns** (columns)
        Select the columns to use perform replace on
    **Default value** (default)
        Specify default value.
    **Search** (find)
        Specify the search pattern that will be replaced.
    **Ignore case** (ignore_case)
        Ignore case when searching
    **Text replace only (using regex)** (literal)
        Perform regex replacements in string columns, i.e., columns with types text and bytes, other columns are ignored. Disable this option to replace full values, without using regex across all types of columns. Learn more about Regular expression syntax in the documentation appendix.
    **Replace** (replace)
        Specify the replacement string.
    **Use default** (use_default)
        Use default value when not found.





Related nodes
.............

* :ref:`org.sysess.sympathy.data.table.tablevaluesearchreplace`






Implementation
..............

.. automodule:: node_table_value_search_replace
    :noindex:

.. class:: TableValueSearchReplaceMultiple
    :noindex: